﻿CREATE TABLE [jnl].[Headcount] (
    [MonthId]         INT             DEFAULT ((-1)) NOT NULL,
    [DataSetId]       TINYINT         DEFAULT ((-1)) NOT NULL,
    [HeadcountTypeId] TINYINT         DEFAULT ((-1)) NOT NULL,
    [UnitId]          INT             DEFAULT ((-1)) NOT NULL,
    [Headcount]       NUMERIC (10, 2) DEFAULT ((0)) NOT NULL,
    [CreatedBy]       NVARCHAR (50)   NULL,
    [UpdatedBy]       NVARCHAR (50)   NULL,
    [UpdatedDate]     DATETIME        NULL,
    PRIMARY KEY CLUSTERED ([MonthId] ASC, [DataSetId] ASC, [HeadcountTypeId] ASC, [UnitId] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF)
);

